How to: Link worksheet data as a picture.
Solution:
Copy the data to be linked as a picture in the source workbook. Switch to the destination workbook and paste the picture link.
1) Open the source workbook.
2) Select the worksheet containing the data to be linked as a picture.
NOTE: Click the tab for a worksheet to select the worksheet.
3) Select the desired data.
4) Select 'Copy' from the 'Edit' menu.
5) Open the destination workbook.
NOTE: If the workbook is already open, select the name of the workbook from the 'Window' menu to switch to the workbook.
6) Select the worksheet to link the data.
7) Select the cell where the upper-left corner of the data should appear.
8) Press and hold down SHIFT.
9) Select 'Paste Picture Link' from the 'Edit' menu.
the Paste Picture Link command
